T -tree: Main Memory Index Structure with Concurrency Control and Recovery
نویسنده
چکیده
While B+trees are the most popular index structure for disk databases, the T-Tree has been widely accepted as a promising index structure for main memory databases. For over two decades the speed of CPUs has increased faster than the speed of the main memory. Therefore, the speed gap of the CPU and memory has rapidly become steeper, and memory access has become the new bottleneck in databases. In this paper we explore concurrency control and recovery in a new index structure T -tree which enhances the cache usage, reduces the number of rotate operations and the overhead required for balancing the tree by delayed split and deletion.
منابع مشابه
T-Tree or B-Tree: Main Memory Database Index Structure Revisited
* The second author's work is partially supported by a grant from the Research Grant Council of Hong Kong Special Administrative Region, China (No. HKUST758/96E ). The third author's work is partially supported by a grant from Sino Software Research Institute (No. SSRI97/98.EG02). 1 On leave from the School of Computing, The National University of Singapore. 2 Currently a visiting scholar at th...
متن کاملLogical and Physical Versioning in Main Memory Databases
We present a design for multi-version concurrency control and recovery in a main memory database, and describe logical and physical versioning schemes that allow read-only transactions to execute without obtaining data item locks or system latches. These schemes enable a system to guarantee that updaters will never interfere with read-only transactions, and that read-only transactions will not ...
متن کاملThe Notion of Performing next Key Locking and Val- a Transaction Processing Testbed for Memory Resident Data. Ieee Transactions on Knowledge and Data En- Gineering, 2(1):161{172
idation after obtaining a lock was presented for B+ trees in Moh90, ML92]. However, in order to prevent insert/delete operations from taking place in a sub-tree that is involved in a structure modiication (e.g., split) and at the same time, to permit traversals (that obtain latches) to execute concurrently on the sub-tree, a tree latch is obtained in exclusive mode during structure modiications...
متن کاملCache-Conscious Concurrency Control of Main-Memory Indexes on Shared-Memory Multiprocessor Systems
Recent research addressed the importance of optimizing L2 cache utilization in the design of main memory indexes and proposed the so-called cache-conscious indexes such as the CSB+-tree. However, none of these indexes took account of concurrency control, which is crucial for running the real-world main memory database applications involving index updates and taking advantage of the off-the-shel...
متن کاملLogical and Physical Versioning in
We present a design for multi-version concur-rency control and recovery in a main memory database, and describe logical and physical versioning schemes that allow read-only transactions to execute without obtaining data item locks or system latches. These schemes enable a system to guarantee that updaters will never interfere with read-only transactions, and that read-only transactions will not...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2007